Agent Central Host Computer/Agent - Central Host Computer.iso/_SETUP.1/vjamsloc.sql

Text File | 2000-05-12 | 447b | 10 lines

CREATE OR REPLACE VIEW VJAMSLOC AS select vjl1.DET_SEQ_NUM,vjl1.FAREBOX_GLID,vjl1.CONV_DATE,vjl1.SHIFT_SEQ,vjl1.USER_ID,
vjl1.ROUTE_ID,vjl1.RUN_ID,vjl1.TRIP_ID,vjl1.FARESET_ID,vjl1.SETCLR,vjl1.ALARM,
vjl1.CURR_TYPE,vjl1.TABLE_CODE,vjl1.EVENT , bus.bus_id
from vjamsloc1 vjl1 , bus, farebox
where trunc(conv_date) > to_date('10-JUL-1999', 'dd-MON-yyyy') and
vjl1.FAREBOX_GLID = FAREBOX.GLID  AND
FAREBOX.LOCATION = BUS.GLID;